hmmi_factory_tour_db - Laravel Schema Designer

user

id increments
email string
password string
timestamps timestamps
softDeletes softDeletes

tour_package

id increments
name string
description text
minimum_participant smallInteger
maximum_participant smallInteger
timestamps timestamps
softDeletes softDeletes

factory

id increments
name string
description text
timestamps timestamps
softDeletes softDeletes

tour

id increments
tour_package_id ^FK bigInteger
tour_number string
name string
tour_date datetime
reschedule_reason text
vehicle_type enum
vehicle_plate_number string
timestamps timestamps
softDeletes softDeletes

tour_participant

id increments
tour_id ^FK bigInteger
name string
age string
sex enum
email string
city string
is_leader tinyInteger
is_special_need tinyInteger
verification_code string
verified_at timestamp
timestamps timestamps
softDeletes softDeletes

tour_feedback

id increments
tour_id ^FK integer
rating float
description string
timestamps timestamps
softDeletes softDeletes

banner

id increments
name string
description text
image_path string
link_url string
is_active tinyInteger
timestamps timestamps
softDeletes timestamp

article

id increments
name string
content longText
img_path string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

whistlerblower_report

id increments
timestamps timestamps
softDeletes softDeletes

factory_route

id increments
factory_id ^FK integer
name string
description text
timestamps timestamps
softDeletes datetime

tour_route

tour_package_id ^FK integer
factory_route_id ^FK integer
order integer
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01